Skip Headers

Oracle® Database Companion CD Installation Guide 10g Release 2 (10.2) for Microsoft Windows (32-Bit) Part Number B14324-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 1 Oracle Database Companion CD Installation Overview

This chapter provides an overview of the products available on the Oracle Database Companion CD and describes issues to consider before you install the products:

- Overview of the Installation Process

- Products Available in the Oracle HTML DB Installation Type

- Products Available in the Oracle Database 10g Products Installation Type

- Products Available in theOracle Database 10g Companion Products Installation Type

## 1.1 Overview of the Installation Process

The installation process consists of six steps:

1. Read the release notes: Read the Oracle Database 10g release 2 (10.2) release notes before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at:

   `http://www.oracle.com/technology/documentation`

2. Plan the installation: This chapter describes the products in the installation types and provides information that you must understand before installing the software.

   You also may want to refer to Appendix A, "Frequently Asked Questions about Installation," in Oracle Database Installation Guide. This appendix advises on the best way to install Oracle products depending on your site's requirements.

3. Verify system requirements: Chapter 2 describes the minimum requirements that your system must meet before you install the software.

4. Install the software: Use the following sections to install the Oracle Database Companion CD products:

   - Chapter 3 describes how to use Oracle Universal Installer to install the software.

   - Appendix A describes how to install Java Access Bridge, which enables the use of a screen reader with Oracle components.

   - Appendix B describes how to perform the installation using silent or noninteractive mode using response files. It also explains how to run Oracle Workflow Configuration Assistant in noninteractive mode.

   - "Installing and Using Oracle Components in Different Languages" describes how to install and use Oracle Database Companion CD components in different languages.

   - Appendix E provides installation troubleshooting advice.

5. Complete postinstallation tasks: Chapter 4 describes recommended and required postinstallation tasks.

6. Get started using the Companion CD products: Use the following sections to get started using Oracle Database Companion CD products:

   - Chapter 5 describes where to go after you have installed the Oracle Database Companion CD products and performed any necessary postinstallation steps: how to check the contents of the installation and how to start and log in to the products you have installed.

   - "Configuring Locale and Character Sets with the NLS_LANG Parameter" explains how to configure the Oracle Database Companion CD locale and character sets.

   - Appendix D describes how to check and modify port numbers.

## 1.2 Products Available in the Oracle HTML DB Installation Type

The following products are available in the Oracle HTML DB installation type:

- Oracle HTML DB

- Oracle HTTP Server

  Note: The Summary window of Oracle Universal Installer provides a detailed list of the products available with the Oracle HTML DB installation type.

### 1.2.1 Oracle HTML DB

Oracle HTML DB is a tool for rapid development and deployment of Web applications on an Oracle database. It provides developers with the productivity of a desktop database, but with the security, reliability, and performance of the Oracle database. With little programming or scripting and only a Web browser, you can build reporting and data entry applications either on existing tables or views or by importing data from spreadsheets.

### 1.2.2 Oracle HTTP Server

Oracle HTTP Server is a Web server that is based on Apache Standalone version 10.2.0.0. Use the Oracle HTML DB installation type to install Oracle HTTP Server in a new Oracle home. (If you are installing Oracle Workflow middle tier components, Oracle HTTP Server is available with Oracle Database 10g Companion Products.) This standalone release of Oracle HTTP Server provides the following features:

- A robust and reliable Web server that you can use to serve Web pages

- Support for Perl and Fast CGI scripts using `mod_perl` and `mod_fastcgi`

- Support for PL/SQL applications using `mod_plsql`

- High-availability, through the use of Oracle Process Manager and Notification server (OPMN)

  OPMN monitors Oracle HTTP Server processes and restarts them if they fail.

- Support for secure transactions using secure socket layer (SSL)

- Single sign-on capabilities using `mod_osso`

  To enable single sign-on, you must use Oracle HTTP Server in conjunction with Oracle Internet Directory and Single Sign-On Server, both of which are available with Oracle Application Server 10g.

- Many standard Apache modules, in addition to modules provided by Oracle

See Also: Oracle Application Server Installation Guide for more information on Oracle Internet Directory and Single Sign-On Server

#### 1.2.2.1 Differences Between this Release and Other Oracle HTTP Server Releases

The standalone version of Oracle HTTP Server differs from the version shipped with other releases of Oracle software, as follows:

- Oracle9i release 2 or earlier, and Oracle9iAS release 1:

  - Apache JServ is not shipped with this release of Oracle HTTP Server, nor does this release support Apache JServ. Because Apache JServ is not supported, the `mod_oprocmgr` module is not loaded in the default configuration.

  - In this release, `mod_ossl`, which Oracle developed, replaces `mod_ssl`.

  - The `apachectl` utility is no longer supported for starting, stopping, or restarting Oracle HTTP Server. You must use Oracle Process Manager and Notification server (OPMN) to start, stop, or restart Oracle HTTP Server.

    See Also: "Step 8: Migrating Your Server Certificate and Private Key" for more information about migrating SSL certificates to the format required by `mod_ossl` "Enabling the High Availablity Features of Oracle HTTP Server" to learn more about using Oracle Process Manager and Notification server

- Oracle9iAS release 2 or later:

  - You cannot configure the standalone release of Oracle HTTP Server in an Oracle9iAS or Oracle Application Server 10g cluster. For this reason, you cannot use the `dcmctl` utility to start, stop, or restart processes associated with this release of Oracle HTTP Server.

  - You cannot use the Oracle Enterprise Manager Application Server Control to administer this release of Oracle HTTP Server.

## 1.3 Products Available in the Oracle Database 10g Products Installation Type

The following products are available with the Oracle Database 10g Products installation type:

- Oracle JDBC Development Drivers

- Oracle SQLJ

- Oracle Database Examples

- Oracle Text Supplied Knowledge Bases

- Oracle Workflow Server

- Oracle Ultra Search

- Natively Compiled Java Libraries

- JPublisher

Note: The Summary window of Oracle Universal Installer provides a detailed list of the products available with the Oracle Database 10g Products installation type. Legato Single Server Version (LSSV) is no longer supported on Oracle Database. Oracle Database Recovery Manager (RMAN), which is a backup and recovery tool integrated into Oracle Database. Oracle Database Backup and Recovery Basics covers RMAN in more detail.

### 1.3.1 Oracle JDBC Development Drivers

Oracle provides a set of JDBC drivers that you can use for debugging your code and other deployment scenarios. These drivers can access Oracle Database release 8.1.7 or later.

See Also: Oracle Technology Network (`http://www.oracle.com/technology/index.html`) for more information on Oracle JDBC Drivers and Oracle Call Interface Oracle Call Interface Programmer's Guide

### 1.3.2 Oracle SQLJ

Oracle SQLJ enables applications programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded SQL statements. Oracle SQLJ offers extensions to support dynamic SQL operations—those that are not predefined, where the operations themselves can change in real-time. It is also possible to use dynamic SQL operations through JDBC code or PL/SQL code within a SQLJ application. Typical applications contain much more static SQL than dynamic SQL. SQLJ has both a translator and a runtime component and is smoothly integrated into your development environment.

### 1.3.3 Oracle Database Examples

Oracle Database Examples include a variety of examples and product demonstrations that you can use to learn about the products, options, and features of Oracle Database. Many of these examples are designed to work with the Sample Schemas which you can optionally install in any Oracle database. Many of the documents in the Oracle Online Documentation Library use the example programs and scripts provided with the Oracle Database Examples.

#### 1.3.3.1 Required Products

Before you can use the Oracle Database Examples, you must install the Sample Schemas into an Oracle database. When you install Oracle Database, or use Database Configuration Assistant (DBCA) to create a new database, you can choose to include the Sample Schemas when you create the database. You can also manually install the Sample Schemas into an existing database.

See Also: Oracle Database Sample Schemas for information about manually installing the Sample Schemas into an existing database

### 1.3.4 Oracle Text Supplied Knowledge Bases

The Oracle Database 10g Products installation type installs two Oracle Text knowledge bases, English and French. You can extend the supplied knowledge bases depending on your requirements. Alternatively, you can create your own knowledge bases, in languages other than English and French.

See Also: Oracle Text Reference for more information about creating and extending knowledge bases

### 1.3.5 Oracle Workflow Server

Oracle Workflow provides a complete workflow management system that supports business process-based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type according to user–defined business rules. The Oracle Workflow installation includes Oracle Workflow server and Oracle Workflow Manager on the Oracle Database Products installation type and the Oracle Workflow middle tier components on the Companion Products installation type.

In this release, starting the Oracle Application Server Containers for J2EE (OC4J) instances for Oracle Workflow Manager has been simplified to running two scripts.

Note: Do not install Oracle Workflow server in an Oracle E-Business Suite database. If you want to use the version of Oracle Workflow available with Oracle Database 10g, or any Oracle Database components that depend on this version of Oracle Workflow, you must install the Oracle Workflow server into a database that is not used for an Oracle E-Business Suite instance.For an Oracle E-Business Suite database, you can continue to use the version of the Oracle Workflow server embedded in Oracle E-Business Suite instead.

See Also: Oracle Workflow Client Installation Guide on Oracle Technology Network (OTN) for information about installing Oracle Workflow Client: `http://www.oracle.com/technology/documentation/` Oracle Workflow Client is available from Oracle Technology Network: `http://www.oracle.com/technology/products/ias/workflow/`

Other Installation Types that Install Oracle Workflow

Oracle Workflow is also installed by some installation types of the following products:

- Oracle Application Server 10g

- Oracle Content Management SDK 10g

If you installed either of these products, you might already have installed Oracle Workflow. In this case, you do not need to install Oracle Workflow again.

### 1.3.6 Oracle Ultra Search

You can use Oracle Ultra Search to build different kinds of search applications. It lets you index and search Web sites, database tables, files, mailing lists, Oracle Application Server Portals, and user-defined data sources.

### 1.3.7 Natively Compiled Java Libraries

The Oracle Database 10g Products installation type installs JAccelerator and Oracle interMedia Image Accelerator which contains the natively compiled Java libraries (NCOMPs) for Oracle JVM and Oracle interMedia. These libraries are required to improve the performance of these products on your platform.

### 1.3.8 JPublisher

JPublisher is a Java utility that generates Java classes to represent the following user-defined database entities a the Java program:

- SQL object types

- Object reference types (REF types)

- SQL collection types (VARRAY types or nested table types)

- PL/SQL packages

- Server-side Java classes

- SQL queries and DML statements

You can use JPublisher to specify and customize the mapping of SQL object types, object reference types, and collection types (VARRAYs or nested tables) to Java classes in a strongly typed paradigm.

JPublisher also can generate classes for PL/SQL packages. These classes have wrapper methods to invoke the stored procedures in the PL/SQL packages.

In addition, JPublisher simplifies access to PL/SQL-only types from Java. You can employ predefined or user-defined mappings between PL/SQL and SQL types, as well as use PL/SQL conversion functions between such types. With such type correspondences in place, JPublisher can automatically generate the required Java and PL/SQL code.

In a similar way that SQL or PL/SQL entities publish to Java, you can publish server-side Java classes to client-side Java classes. Doing this enables applications to make direct calls to Java classes in the database.JPublisher lets you expose generated Java classes as Web services, for example. You can publish either SQL or PL/SQL entities or server-side Java entities.

JPublisher uses SQLJ code in most Java classes that it generates, so it includes Oracle SQLJ Translator and Oracle SQLJ Runtime. Oracle SQLJ is a standard way to embed SQL statements in Java programs.

Oracle SQLJ Translator

Because JPublisher uses SQLJ code in its generated classes, it automatically invokes the Oracle SQLJ translator during the code generation process, as necessary. The translator converts embedded SQL statements into JDBC calls.

Oracle SQLJ Runtime

Oracle SQLJ Runtime is used during program execution to execute most classes that were generated by JPublisher. SQLJ Runtime is a thin layer of pure Java code that runs above the JDBC driver. It acts as an intermediary that reads information about SQL operations and passing instructions along to the JDBC driver.

See Also: Oracle Database JPublisher User's Guide

## 1.4 Products Available in the Oracle Database 10g Companion Products Installation Type

The following products are available with the Oracle Database 10g Companion Products installation type:

- Oracle Workflow Middle Tier Components

- Oracle HTTP Server

Note: The Summary window of Oracle Universal Installer provides a detailed list of the products available with the Oracle Database 10g Companion Products installation type.

### 1.4.1 Oracle Workflow Middle Tier Components

Oracle Workflow middle tier components enable the Oracle Workflow user interface Web pages, including the Database Access Descriptor (DAD) and virtual directory mappings for Oracle Workflow. Before you can use Oracle Workflow server, you must install Oracle Workflow middle tier components. The Oracle Workflow middle tier components are associated with one Oracle database, the database for which Oracle Workflow server is installed.

Use the Oracle Database 10g Companion Products installation type to install the Oracle Workflow middle tier components after you install Oracle Workflow server.

### 1.4.2 Oracle HTTP Server

"Oracle HTTP Server" describes Oracle HTTP Server in detail.